package com.comac.tasks.manager.app.gatewayimpl.database;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.comac.tasks.manager.app.dto.PageResponse;
import com.comac.tasks.manager.app.dto.TasksManagerQry;
import com.comac.tasks.manager.app.gatewayimpl.database.dataobject.TasksManagerTodoDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

/**
 * @author wfb
 * @date 2021年12月15日17:53:14
 */
@Mapper
@Repository
public interface TasksManagerTodoMapper extends BaseMapper<TasksManagerTodoDO> {

    @Select("SELECT id, tasks_content, process_instance_name, creator, create_time, process_create_time, expected_completion_time, task_instance_id, source_application_num, jump_connection, is_transfer, is_urgent, field_area, status, operator, operator_name, process_name, process_code, process_instance_id, source_application_name, process_node_status, node_code, node_name, remark, delete_flag, creator_name, update_time FROM tasks_manager_todo_info  where creator='100086' and delete_flag = '0' GROUP BY process_instance_id order by create_time asc")
    List<TasksManagerTodoDO> selectPageByCreator(TasksManagerQry qry);
}
